home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
sec_levels.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
28 lines
/* RCSVER $Id: sec_levels.sql,v 1.2 1999-02-24 15:12:23-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: sec_levels.sql
* Date: 02/17/1999
* memo: Randy Wood
* Description: Create the sec_levels table. This table contains a list
* of security levels by user id. If no entry exists in
* this table for a user, the security level for that
* user is taken from the opsecurities table.
* Changes:
************************************************************************* */
CREATE TABLE sec_levels
(
user_id NUMBER(38) /* ID of user */
CONSTRAINT ref1_seclevels REFERENCES
users(user_id) ON DELETE CASCADE,
subsys_id NUMBER(38) /* Subsystem for this sec. level */
CONSTRAINT ref2_seclevels REFERENCES
subsystems(id) ON DELETE CASCADE,
security_level NUMBER(38), /* security level for user */
CONSTRAINT fk_seclevels FOREIGN KEY (subsys_id, security_level)
REFERENCES subsecurities(subsys_id, sec_level)
ON DELETE CASCADE,
CONSTRAINT pk_seclevels PRIMARY KEY (user_id, subsys_id)
);